home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Magnum One
/
Magnum One (Mid-American Digital) (Disc Manufacturing).iso
/
d13
/
qptech.arc
/
TI589.ASC
< prev
next >
Wrap
Text File
|
1991-04-25
|
5KB
|
199 lines
PRODUCT : Quattro Pro NUMBER : 589
VERSION : All
OS : PC DOS
DATE : March 15, 1991 PAGE : 1/3
TITLE : Centering a Title on a Block of Cells
Quattro Pro allows text to be centered within a cell but not
within a range of cells. The following formula provides a means
for centering a text string over any block of cells.
=================================================================
@REPEAT(" ",@CELL("rwidth",Blockname)/2.0-@LENGTH("Your Title")/2)&"Your Title"
=================================================================
THE BASIC PROCEDURE
o The formula must be entered in one cell.
o The only space in the formula is between the quotes at the
beginning of the formula. This space pads the beginning
of the text string so that it will be centered.
o Blockname in this formula can be replaced with any cell or
block, a block name, or any function that returns a block.
This block of cells defines the range over which the text
will be centered.
o Replace the text Your Title with the text to be centered.
o The value 2.0 may need to be adjusted to compensate for
different fonts, point sizes, use of a Left Heading, or
the Print To Fit feature (only in Quattro Pro v3.0) when
printing. Increasing this value (e.g., 2.2, 2.8, etc.)
will shift the title toward the left; decreasing it (e.g.,
1.3, 1.6, etc.) will shift the title toward the right.
PRODUCT : Quattro Pro NUMBER : 589
VERSION : All
OS : PC DOS
DATE : March 15, 1991 PAGE : 2/3
TITLE : Centering a Title on a Block of Cells
MODIFYING THE FORMULA
The formula can be modified to increase its flexibility by
storing the arguments in separate cells and referencing those
cells within the formula.
1. Defining the text of the title to be centered.
Store Your Title (omitting the quote marks) in cell T3, for
example, and reference this cell in the formula.
Example:
@REPEAT(" ",@CELL("rwidth",Blockname)/2.0-@LENGTH(T3)/2)&T3
2. Defining the block over which the title is to be centered.
Use specific cell coordinates of the block, such as
B25..H98, over which the title is to be centered.
Example:
@REPEAT(" ",@CELL("rwidth",B25..H98)/2.0-@LENGTH("Your Title")/2)&"Your Title"
Use a name which has been assigned to a specific block of
cells through </> <Edit> <Names>, such as JulySales.
Example:
@REPEAT(" ",@CELL("rwidth",JulySales)/2.0-@LENGTH("Your Title")/2)&"Your Title"
PRODUCT : Quattro Pro NUMBER : 589
VERSION : All
OS : PC DOS
DATE : March 15, 1991 PAGE : 3/3
TITLE : Centering a Title on a Block of Cells
Use a function which returns a block. For example, the
function @CURVALUE("print","block") finds the block
currently defined in </> <Print> <Block>. Store this
function in cell T2, then use the @@ function with T2 to
return its value.
Example:
@REPEAT(" ",@CELL("rwidth",@@(T2))/2.0-@LENGTH("Your Title")/2)&"Your Title"
3. Determining the width of the block.
The function @CELL("rwidth",block) returns number of
characters in block's width. After choosing one of the
methods above for defining the block, store the @CELL
function in cell T1, for example, and the title centering
formula becomes:
@REPEAT(" ",T1/2.0-@LENGTH("Your Title")/2)&"Your Title"
FINE TUNING
This formula will return ERR if the block has not been defined.
Define the block and press F9 to recalculate the formula. If the
block size has been changed, the title will not automatically
reposition itself. Again, press F9 to recalculate the formula.
Use Quattro Pro's Screen Preview feature to check the position of
the title. Remember, the title will be centered over the entire
block. If, for example, the block is 12 columns wide and prints
on two pages, the title will be positioned near the right edge of
the first page because it is being centered over all 12 columns,
not just the columns on the first page. If the title is to be
centered on the first page only or over a print block plus Left
Headings (columns defined as a Left Heading are not included when
calculating the width of the print block), adjust the formula to
move the title toward the left.